<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Create Encrypted Connection String</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
body /* This body tag requires the use of one of the sets of banner and/or text div ids */
	{
	margin: 15px;
	padding: 0px 0px 0px 0px;
	background: #ffffff; 
	color: #000000;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 70%;
	width: 100%;
	/*overflow: expression('hidden');*/
	}
	
pre {
	font-size:11px;
}

h1 {
	color:maroon;
	border-bottom:1px solid silver;
	margin-bottom: 20px;
}
h2 {
	border-bottom:1px solid silver;
	margin-top:25px;
}

h4 {
	font-size:120%;
}
</style>

</head>

<body>
<h1>BizBlox Builder</h1>
<h2>Advanced Features</h2>
<h3>Create Encrypted Connection String </h3>
<p>BizBlox Builder includes an optional utility to create Encrypted Connection Strings, which can be used securely in your web.config file.</p>
<p>Version 0.9.8.1 of BizBlox introduces an algorithmic approach to creating secure connection strings which creates a salted SHA1 hash from the machine name. This approach will operate without any need to change permissions of the 'anonymous' user role and is more secure than the previous approach [required by the initial release of 0.9.8]. <br>
  <br>
This means you can deploy BizBlox to any .Net hosted environment and happily use the encrypted connection strings without fear of permissions clash. It also means you can deploy the <em>GetHardwareID.aspx </em> page to any server with the <em>BizBlox.DLL </em> available to the app domain and get the key for creating a secure connection string with the SQL Import Tool. <br>
<br>
To create a secure connection string just go to <strong>Tools </strong> -&gt; <strong>Create Encrypted Connection String </strong> and uncheck the <strong>Use this computer's Hardware ID </strong> and paste in the key you get when viewing the <em>GetHardwareID.aspx </em> page on a web browser. Then paste in your plain text connection string in to the <strong>Source Connection String </strong> text box. The plain text connection string should be in the form: <br>
<br>
data source=&lt;Your Database Server&gt;;Initial Catalog=&lt;Database Name&gt;;User Id=&lt;Database User ID&gt;;pwd=&lt;Database User Password&gt;; <br>
<br>
Click <strong>Encrypt to Clipboard </strong> button and then open your <em>web.config </em> file. <br>
<br>
&lt;add key="Pixolut.BizBlox.EncryptedConnectionString.MyServerName" value="***Paste the copied text in here***" /&gt; <br>
&lt;add key="Pixolut.BizBlox.ActiveConnection" value="MyServerName"&gt;&lt;/add&gt; <br>
<br>

You can define as many named connection strings as you want - however the connection specified by the <em>Pixolut.BizBlox.ActiveConnection </em> property is the connection currently being used. <br>
<br>
Note that <strong>BizBlox </strong> does not support insecure named connections. Only <em>EncryptedConnectionString </em> entries can be named and set active for the BizBlox DSNManager.</p>
<p>&nbsp;</p>
<h4>&nbsp;</h4>
</body>
</html>
